Changing SQL Server Setting Parameters via Remote SSMS (SQL Server Management Studio)

This article describes how you can change setting parameters for SQL Server via remote SSMS.

1. Create a super user

You will need a super user so you can make changes to setting parameters. To create a user, please refer to Creating Databases and Users.

To find the detailed steps about connecting database via SSMS. Please refer to the link at Connecting SQL Server Using SSMS .

Right click the SQL Server instance. Click Properties.

Change the Maximum number of concurrent connections on menu Connections.

Change Default Language on menu Advanced.

Right click a database. Click Properties.

Change the database Collation on menu Options.